MySQL部署 (CenterOS,OSX)
CenterOS
使用链接
root用户登入Linux
使用yum 命令安装MySQL，安装完毕后，mysql 数据库路径在/var/lib/mysql ，配置文件路径为/etc/my.cnf
1
2
3
| sudo yum install mysql
sudo yum install mysql-server
sudo yum install mysql-devel
|
可能出现的问题
在CenterOS7安装mysql 时 可能提示 No package mysql-server available
原因：
1
| CentOS7带有MariaDB而不是MySQL，MariaDB和MySQL一样也是开元的数据库，您可以使用yum -y install mariadb-server mariadb命令安装
|
解决方案：
1
| 如果必须要安装MySQL，首先必须添加mysql社区repo通过输入命令：sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm，最后使用像安装MySQL的常规方法一样安装mysql： yum install mysql mysql-server mysql-libs mysql-server
|
将/var/lib/mysql的用户群改成mysql，并赋予属主和属组权限
1
2
| sudo chgrp -R mysql /var/lib/mysql
chmod -R 770 /var/lib/mysql
|
启动mysql服务，设置登录mysql的用户、密码
1
2
3
| sudo service mysqld start
/usr/bin/mysqladmin -u root password '你的密码'
|
登陆MySQL root
设置mysql编码
（1）进入mysql，先查看当前数据库编码状态
1
| SHOW VARIABLES LIKE 'character_set_%';
|
+————————–+—————————-+
| Variable_name | Value |
+————————–+—————————-+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+————————–+—————————-+
（2）编码修改
1
2
3
4
5
| set character_set_server=utf8;
set character_set_database=utf8;
SHOW VARIABLES LIKE 'character_set_%';
|
+————————–+—————————-+
| Variable_name | Value |
+————————–+—————————-+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+————————–+—————————-+
创建数据库
1
| CREATE DATABASE <datebasename> CHARACTER SET utf8;
|
CREATE DATABASE MK_BaseDataBase CHARACTER SET utf8;
创建账户
1
| create user '用户名'@'主机地址' identified by '密码';
|
授权数据库
1
| grant 授权列表 on `数据库名`.* to 用户名@''
|
退出MySQl登陆
Ctrl + D
OSX
安装MySQL
